HPS MM-EYE

Author

Joseph H

1 Intoduction

Hello, I’m Joseph from Morocco.

Inspired by Hans Rosling’s TED Talk, I taught myself data scraping, analysis, and visualization.
This non-academic approach has given me a unique perspective, as reflected in my projects—though it also means I may require a thorough onboarding process to align with team standards.

I’m open to starting as an intern, either full-time or part-time. Regarding time zones, I’m in UTC+1, but I’m flexible and can adjust my schedule to accommodate the team’s needs.

Feel free to reach me at joseph.ergo@proton.me, and to visit my website for more projects josephelhaddad.github.io.

This custom report, generated from processing 1.4 TB of public data locally, aims to explore the workforce dynamics of a company—up to 2020.
Essentially, I am doing research on a company that does research.

2 About the project

The project came to life after realizing that web scraping doesn’t allow deep-level filtering—without consuming too much time.The irony is, this project itself took me about a month, but the final RDB contains more data than I could ever scrape.

The raw data was 1.4 TB in size and holds information previously scraped.
Processing was done on my local machine using Python, Polars, and DuckDB, following this workflow:
- Processed raw data into structured Parquet files using Polars.
- Transformed each Parquet file into mini RDBs using Polars.
- Merged all mini RDBs into one using DuckDB.
- Analyzed and filtered data to fit the current project.

Alt text

3 EDA

3.1 market research indestry’s yearly new recruit count

3.2 hps mm-eye’s workforce status over the years

4 Workforce sample

4.1 Alexandra Szpilska

Job title: Services executive
Associated: False
Socials: https://linkedin.com/in/alexandra-szpilska-8306462b

4.1.1 Alexandra Szpilska’s working period at hps mm-eye

4.1.2 Gantt plot of Alexandra Szpilska’s experience

4.2 Anne Bolingbroke

Job title: Managing director
Associated: True
Socials: https://linkedin.com/in/anne-bolingbroke-935a0a10

4.2.1 Anne Bolingbroke’s working period at hps mm-eye

4.2.2 Gantt plot of Anne Bolingbroke’s experience

4.3 David Chapman

Job title: Research executive trainee
Associated: False
Socials: https://linkedin.com/in/david-chapman | https://linkedin.com/in/david-chapman-795158a7

4.3.1 David Chapman’s working period at hps mm-eye

4.3.2 Gantt plot of David Chapman’s experience

4.4 Deborah Fitzpatrick

Job title: Deputy managing director
Associated: True
Socials: https://linkedin.com/in/deborah-fitzpatrick-70718b33

4.4.1 Deborah Fitzpatrick’s working period at hps mm-eye

4.4.2 Gantt plot of Deborah Fitzpatrick’s experience

4.5 Ina Plewa

Job title: Manager field operations
Associated: False
Socials: https://linkedin.com/in/ina-plewa-42bab966

4.5.1 Ina Plewa’s working period at hps mm-eye

4.5.2 Gantt plot of Ina Plewa’s experience

4.6 Jennifer Mallett

Job title: Research manager
Associated: False
Socials: https://linkedin.com/in/jennifer-mallett-55307222

4.6.1 Jennifer Mallett’s working period at hps mm-eye

4.6.2 Gantt plot of Jennifer Mallett’s experience

4.7 Mandi Kalair

Job title: Office manager and executive assistant to managing director
Associated: False
Socials: https://linkedin.com/in/mandi-kalair-199512b | https://twitter.com/mandikalair

4.7.1 Mandi Kalair’s working period at hps mm-eye

4.7.2 Gantt plot of Mandi Kalair’s experience

4.8 Matthew Crane

Job title: Data consultant
Associated: True
Socials: https://linkedin.com/in/matthew-crane-6b807613

4.8.1 Matthew Crane’s working period at hps mm-eye

4.8.2 Gantt plot of Matthew Crane’s experience

4.9 Meg Rudman-Walsh

Job title: Research director
Associated: True
Socials: https://linkedin.com/in/megrw

4.9.1 Meg Rudman-Walsh’s working period at hps mm-eye

4.9.2 Gantt plot of Meg Rudman-Walsh’s experience

4.10 Michael Bell

Job title: Research analyst
Associated: False
Socials: https://linkedin.com/in/michael-bell-3a32bb99 | https://facebook.com/bellyblah

4.10.1 Michael Bell’s working period at hps mm-eye

4.10.2 Gantt plot of Michael Bell’s experience

4.11 Nicole Müllner

Job title: Assistant to the managing partner, director and to the team
Associated: False
Socials: https://linkedin.com/in/nicole-müllner-3281733

4.11.1 Nicole Müllner’s working period at hps mm-eye

4.11.2 Gantt plot of Nicole Müllner’s experience

4.12 Ole Wassermann

Job title: Research manager
Associated: False
Socials: https://linkedin.com/in/ole-a-wassermann-1328a928

4.12.1 Ole Wassermann’s working period at hps mm-eye

4.12.2 Gantt plot of Ole Wassermann’s experience

4.13 Phil Torode

Job title: Head of data management
Associated: True
Socials: https://linkedin.com/in/phil-torode-65499b4b | https://facebook.com/phil.torode.3

4.13.1 Phil Torode’s working period at hps mm-eye

4.13.2 Gantt plot of Phil Torode’s experience

4.14 Rebecca Wideson

Job title: Senior services executive
Associated: False
Socials: https://linkedin.com/in/rebecca-wideson-bb142a12

4.14.1 Rebecca Wideson’s working period at hps mm-eye

4.14.2 Gantt plot of Rebecca Wideson’s experience

4.15 Sherine Arafa

Job title: Research director
Associated: True
Socials: https://linkedin.com/in/sherine-arafa-47b2b1 | https://linkedin.com/in/sherinearafa

4.15.1 Sherine Arafa’s working period at hps mm-eye

4.15.2 Gantt plot of Sherine Arafa’s experience

4.16 Sue Aitken

Job title: Part time business development consultancy
Associated: False
Socials: https://linkedin.com/in/sueaitkenmarketing